﻿CREATE PROCEDURE [acms].[Role_GetAllBySiteId]
	@SiteID int
AS
	SELECT *
	From Role
	Where IsNull(SiteId, @SiteId) = @SiteId
RETURN 0;